The compatibility setting also determines the keywords that are reserved by the database engine 兼容性設置還確定了數(shù)據(jù)庫引擎所保留的關鍵字。
When the compatibility setting of a database is changed , all of its stored procedures are automatically recompiled accordingly . environmental considerations for using sp dbcmptlevel 在更改某一數(shù)據(jù)庫的兼容性設置時,該數(shù)據(jù)庫的所有存儲過程都將隨之自動重新編譯。
The new compatibility setting for a database takes effect when the database is next made current whether as the default database on login or on being specified in a use statement 數(shù)據(jù)庫的新兼容性設置將在該數(shù)據(jù)庫下次成為當前數(shù)據(jù)庫(無論是在登錄時作為默認數(shù)據(jù)庫還是在use語句中指定)時生效。